load->model("Project_model");
$this->load->model("Xin_model");
$this->load->model("Company_model");
$this->load->model("Department_model");
$this->load->model("Designation_model");
$this->load->model("Timesheet_model");
$this->load->model("Employees_model");
$this->load->model("Timesheet_model");
$this->load->model("Clients_model");
$this->load->model("Exin_model");
$this->load->model("Invoices_model");
$this->load->model("Quotes_model");
$this->load->model("Finance_model");
$this->load->model("Quoted_project_model");
$this->load->library('email');
}
/*Function to set JSON output*/
public function output($Return=array()){
/*Set response header*/
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
/*Final JSON response*/
exit(json_encode($Return));
}
public function index()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('admin/dashboard');
}
$data['title'] = $this->lang->line('xin_projects').' | '.$this->Xin_model->site_title();
$data['all_employees'] = $this->Xin_model->all_employees();
$data['all_companies'] = $this->Xin_model->get_companies();
$data['all_clients'] = $this->Clients_model->get_all_clients();
$data['breadcrumbs'] = $this->lang->line('xin_projects');
$data['path_url'] = 'project';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/project_list", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
} else {
redirect('admin/dashboard');
}
}
public function projects_dashboard()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('hr_project_dashboard_title').' | '.$this->Xin_model->site_title();
$data['all_departments'] = $this->Department_model->all_departments();
$data['all_designations'] = $this->Designation_model->all_designations();
$data['all_office_shifts'] = $this->Employees_model->all_office_shifts();
$data['get_all_companies'] = $this->Xin_model->get_companies();
$data['all_leave_types'] = $this->Timesheet_model->all_leave_types();
$data['get_invoices'] = $this->Invoices_model->get_invoices();
$data['get_quotes'] = $this->Quotes_model->get_quotes();
$data['get_projects'] = $this->Project_model->get_projects();
$data['all_tasks'] = $this->Timesheet_model->get_tasks();
$data['get_invoice_payments'] = $this->Finance_model->get_invoice_payments();
$data['leads_follow_up_all'] = $this->Quoted_project_model->get_leads_follow_up_all();
$data['breadcrumbs'] = $this->lang->line('hr_project_dashboard_title');
$data['path_url'] = 'projects_dashboard';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/project_dashboard", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
} else {
redirect('admin/dashboard');
}
}
public function timelogs()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('admin/dashboard');
}
$data['title'] = $this->lang->line('xin_project_timelogs').' | '.$this->Xin_model->site_title();
$data['all_employees'] = $this->Xin_model->all_employees();
$data['all_companies'] = $this->Xin_model->get_companies();
$data['all_projects'] = $this->Project_model->get_all_projects();
$data['all_clients'] = $this->Clients_model->get_all_clients();
$data['breadcrumbs'] = $this->lang->line('xin_project_timelogs');
$data['path_url'] = 'project_timelogs';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/project_timelogs_list", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
} else {
redirect('admin/dashboard');
}
}
//projects calendar
public function projects_calendar() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_projects_calendar');
$data['breadcrumbs'] = $this->lang->line('xin_hr_projects_calendar');
$data['all_tasks'] = $this->Timesheet_model->get_tasks();
$data['all_projects'] = $this->Project_model->get_projects();
$data['path_url'] = 'projects_calendar';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/project/projects_calendar", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
//tasks calendar
public function tasks_calendar() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_tasks_calendar');
$data['breadcrumbs'] = $this->lang->line('xin_tasks_calendar');
$data['all_tasks'] = $this->Timesheet_model->get_tasks();
$data['all_projects'] = $this->Project_model->get_projects();
$data['path_url'] = 'projects_calendar';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('45',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/project/tasks_calendar", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
//tasks scrum board
public function tasks_scrum_board() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_tasks_sboard');
$data['breadcrumbs'] = $this->lang->line('xin_tasks_sboard');
$data['all_tasks'] = $this->Timesheet_model->get_tasks();
$data['all_projects'] = $this->Project_model->get_projects();
$data['path_url'] = 'tasks_scrum_board';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('45',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/project/task_scrum_baord", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
//projects scrum board
public function projects_scrum_board() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_projects_sboard');
$data['breadcrumbs'] = $this->lang->line('xin_projects_sboard');
$data['all_tasks'] = $this->Timesheet_model->get_tasks();
$data['all_projects'] = $this->Project_model->get_projects();
$data['path_url'] = 'projects_scrum_board';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/project/project_scrum_baord", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// get company > employees
public function get_employees() {
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get("cid");//$this->uri->segment(4);
$data = array(
'company_id' => $id
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/get_employees", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
// get company > project employees
public function get_project_employees() {
$data['title'] = $this->Xin_model->site_title();
$id = $this->uri->segment(4);
$result = $this->Project_model->read_project_information($id);
if(is_null($result)){
redirect('admin/project/timelogs');
}
$data = array(
'project_id' => $id,
'assigned_to' => $result[0]->assigned_to,
'company_id' => $result[0]->company_id
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/get_project_employees", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
// update task status
public function update_task_scrum_board_status() {
$data['title'] = $this->Xin_model->site_title();
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$task_id = $this->uri->segment(4);
$task_status = $this->uri->segment(5);
$data = array(
'task_status' => $task_status,
);
$result = $this->Timesheet_model->update_task_record($data,$task_id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_task_status');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
// update project status
public function update_project_scrum_board_status() {
$data['title'] = $this->Xin_model->site_title();
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$project_id = $this->uri->segment(4);
$project_status = $this->uri->segment(5);
$data = array(
'status' => $project_status,
);
$result = $this->Project_model->update_record($data,$project_id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_project_status');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
public function invoices()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('admin/dashboard');
}
$data['title'] = $this->Xin_model->site_title();
$data['all_employees'] = $this->Xin_model->all_employees();
$data['all_companies'] = $this->Xin_model->get_companies();
$data['all_clients'] = $this->Clients_model->get_all_clients();
$data['breadcrumbs'] = $this->lang->line('xin_projects');
$data['path_url'] = 'project';
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('44',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/project_list", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
} else {
redirect('admin/dashboard');
}
}
public function detail()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('admin/dashboard');
}
/*$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('318',$role_resources_ids)) { //view
redirect('admin/project');
}*/
$data['title'] = $this->Xin_model->site_title();
//$data['all_employees'] = $this->Xin_model->all_employees();
//$data['all_companies'] = $this->Xin_model->get_companies();
//$data['breadcrumbs'] = $this->lang->line('xin_project_detail');
$id = $this->uri->segment(4);
$result = $this->Project_model->read_project_information($id);
if(is_null($result)){
redirect('admin/project');
}
$edata = array(
'is_notify' => 0,
);
$this->Xin_model->update_notification_record($edata,$id,$session['user_id'],'projects');
// get user > added by
$user = $this->Xin_model->read_user_info($result[0]->added_by);
// user full name
if(!is_null($user)){
$full_name = $user[0]->first_name.' '.$user[0]->last_name;
} else {
$full_name = '--';
}
$result2 = $this->Clients_model->read_client_info($result[0]->client_id);
if(!is_null($result2)) {
$client_name = $result2[0]->name;
} else {
$client_name = '--';
}
$data = array(
'breadcrumbs' => $this->lang->line('xin_project_detail'),
'project_id' => $result[0]->project_id,
'title' => $result[0]->title,
'project_note' => $result[0]->project_note,
'summary' => $result[0]->summary,
'client_id' => $result[0]->client_id,
'client_name' => $client_name,
'start_date' => $result[0]->start_date,
'end_date' => $result[0]->end_date,
'company_id' => $result[0]->company_id,
'assigned_to' => $result[0]->assigned_to,
'created_at' => $result[0]->created_at,
'priority' => $result[0]->priority,
'added_by' => $full_name,
'description' => $result[0]->description,
'progress' => $result[0]->project_progress,
'project_no' => $result[0]->project_no,
'budget_hours' => $result[0]->budget_hours,
'status' => $result[0]->status,
'path_url' => 'project_detail',
'all_clients' => $this->Clients_model->get_all_clients(),
'all_employees' => $this->Xin_model->all_employees(),
'all_companies' => $this->Xin_model->get_companies()
);
//$role_resources_ids = $this->Xin_model->user_role_resource();
//if(in_array('7',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/project_details", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
/*} else {
redirect('dashboard/');
}*/
}
public function project_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/project_list", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$role_resources_ids = $this->Xin_model->user_role_resource();
$user_info = $this->Xin_model->read_user_info($session['user_id']);
if($user_info[0]->user_role_id==1){
$project = $this->Project_model->get_projects();
} else {
if(in_array('318',$role_resources_ids)) {
$project = $this->Project_model->get_company_projects($user_info[0]->company_id);
} else {
$project = $this->Project_model->get_employee_projects($session['user_id']);
}
}
$data = array();
foreach($project->result() as $r) {
$aim = explode(',',$r->assigned_to);
// get user > added by
$user = $this->Xin_model->read_user_info($r->added_by);
// user full name
if(!is_null($user)){
$full_name = $user[0]->first_name.' '.$user[0]->last_name;
} else {
$full_name = '--';
}
// get date
$psdate = $this->Xin_model->set_date_format($r->start_date);
$pedate = $this->Xin_model->set_date_format($r->end_date);
//project_progress
if($r->project_progress <= 20) {
$progress_class = 'bg-danger';
} else if($r->project_progress > 20 && $r->project_progress <= 50){
$progress_class = 'bg-warning';
} else if($r->project_progress > 50 && $r->project_progress <= 75){
$progress_class = 'bg-info';
} else {
$progress_class = 'bg-success';
}
// progress
$pbar = ''.$this->lang->line('xin_completed').' '.$r->project_progress.'%
';
//status
if($r->status == 0) {
$status = ''.$this->lang->line('xin_not_started').'';
} else if($r->status ==1){
$status = ''.$this->lang->line('xin_in_progress').'';
} else if($r->status ==2){
$status = ''.$this->lang->line('xin_completed').'';
} else if($r->status ==3){
$status = ''.$this->lang->line('xin_project_cancelled').'';
} else {
$status = ''.$this->lang->line('xin_project_hold').'';
}
// priority
if($r->priority == 1) {
$priority = ''.$this->lang->line('xin_highest').'';
} else if($r->priority ==2){
$priority = ''.$this->lang->line('xin_high').'';
} else if($r->priority ==3){
$priority = ''.$this->lang->line('xin_normal').'';
} else {
$priority = ''.$this->lang->line('xin_low').'';
}
//assigned user
if($r->assigned_to == '') {
$ol = $this->lang->line('xin_not_assigned');
} else {
$ol = '';
foreach(explode(',',$r->assigned_to) as $desig_id) {
$assigned_to = $this->Xin_model->read_user_info($desig_id);
if(!is_null($assigned_to)){
$assigned_name = $assigned_to[0]->first_name.' '.$assigned_to[0]->last_name;
if($assigned_to[0]->profile_picture!='' && $assigned_to[0]->profile_picture!='no file') {
$ol .= '.'uploads/profile/'.$assigned_to[0]->profile_picture.')
';
} else {
if($assigned_to[0]->gender=='Male') {
$de_file = base_url().'uploads/profile/default_male.jpg';
} else {
$de_file = base_url().'uploads/profile/default_female.jpg';
}
$ol .= '
';
}
} ////
else {
$ol .= '';
}
}
$ol .= '';
}
if(in_array('316',$role_resources_ids)) { //edit
$edit = '';
$add_users = ' ';
} else {
$edit = '';
$add_users = '';
}
if(in_array('317',$role_resources_ids)) { // delete
$delete = '';
} else {
$delete = '';
}
$client = $this->Clients_model->read_client_info($r->client_id);
if(!is_null($client)) {
$client_name = $client[0]->name;
} else {
$client_name = '--';
}
$new_time = $this->Xin_model->actual_hours_timelog($r->project_id);
$project_summary = ''.$r->title.'
'.$this->lang->line('xin_project_client').': '.$client_name.'
'.$this->lang->line('xin_project_budget_hrs').': '.$r->budget_hours.'
'.$this->lang->line('xin_project_actual_hrs').': '.$new_time.'';
$project_date = $this->lang->line('xin_start_date').': '.$psdate.'
'.$this->lang->line('xin_end_date').': '.$pedate;
// progress
$project_progress = $pbar.$status;
$project_no = ''.$r->project_no.'';
$combhr = $edit.$delete;
$data[] = array(
$combhr,
$project_no,
$r->phase_no,
$project_summary,
$priority,
$ol.$add_users,
$project_date,
$project_progress,
);
// } //}
}
$output = array(
"draw" => $draw,
"recordsTotal" => $project->num_rows(),
"recordsFiltered" => $project->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function read()
{
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('project_id');
$result = $this->Project_model->read_project_information($id);
$result2 = $this->Clients_model->read_client_info($result[0]->client_id);
if(!is_null($result2)) {
$client_name = $result2[0]->name;
} else {
$client_name = '--';
}
$data = array(
'project_id' => $result[0]->project_id,
'title' => $result[0]->title,
'client_id' => $result[0]->client_id,
'client_name' => $client_name,
'start_date' => $result[0]->start_date,
'end_date' => $result[0]->end_date,
'company_id' => $result[0]->company_id,
'priority' => $result[0]->priority,
'summary' => $result[0]->summary,
'project_no' => $result[0]->project_no,
'purchase_no' => $result[0]->purchase_no,
'phase_no' => $result[0]->phase_no,
'budget_hours' => $result[0]->budget_hours,
'assigned_to' => $result[0]->assigned_to,
'description' => $result[0]->description,
'project_progress' => $result[0]->project_progress,
'status' => $result[0]->status,
'all_clients' => $this->Clients_model->get_all_clients(),
'all_employees' => $this->Xin_model->all_employees(),
'all_companies' => $this->Xin_model->get_companies()
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_project', $data);
} else {
redirect('admin/');
}
}
public function get_scrumboard_task()
{
$data['title'] = $this->Xin_model->site_title();
$task_status = $this->input->get('task_status');
//$result = $this->Project_model->read_project_information($id);
$data = array(
'task_status' => $task_status,
'all_projects' => $this->Project_model->get_all_projects(),
'all_employees' => $this->Xin_model->all_employees(),
'all_companies' => $this->Xin_model->get_companies()
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_scrumboard_task', $data);
} else {
redirect('admin/');
}
}
public function get_scrumboard_project()
{
$data['title'] = $this->Xin_model->site_title();
$project_status = $this->input->get('project_status');
$data = array(
'project_status' => $project_status,
'all_employees' => $this->Xin_model->all_employees(),
'all_companies' => $this->Xin_model->get_companies(),
'all_clients' => $this->Clients_model->get_all_clients()
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_scrumboard_project', $data);
} else {
redirect('admin/');
}
}
// Validate and add info in database
public function add_scrum_board_task() {
if($this->input->post('add_type')=='task') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$description = $this->input->post('description');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
$qt_description = htmlspecialchars(addslashes($description), ENT_QUOTES);
/* Server side PHP input validation */
if($this->input->post('company_id')==='') {
$Return['error'] = $this->lang->line('error_company_field');
} else if($this->input->post('task_name')==='') {
$Return['error'] = $this->lang->line('xin_error_task_name');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('task_hour')==='') {
$Return['error'] = $this->lang->line('xin_error_task_hour');
} else if($this->input->post('project_id')==='') {
$Return['error'] = $this->lang->line('xin_error_project_field');
} else if($this->input->post('assigned_to')==='') {
$Return['error'] = $this->lang->line('xin_error_task_assigned_user');
}
if($Return['error']!=''){
$this->output($Return);
}
$assigned_ids = implode(',',$this->input->post('assigned_to'));
// get company name by project id
$co_info = $this->Project_model->read_project_information($this->input->post('project_id'));
$data = array(
'project_id' => $this->input->post('project_id'),
'company_id' => $this->input->post('company_id'),
'created_by' => $this->input->post('user_id'),
'task_name' => $this->input->post('task_name'),
'assigned_to' => $assigned_ids,
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'task_hour' => $this->input->post('task_hour'),
'task_progress' => '0',
'task_status' => $this->input->post('task_status'),
'is_notify' => '1',
'description' => $qt_description,
'created_at' => date('Y-m-d h:i:s')
);
$result = $this->Timesheet_model->add_task_record($data);
if ($result == TRUE) {
$row = $this->db->select("*")->limit(1)->order_by('task_id',"DESC")->get("xin_tasks")->row();
$Return['result'] = $this->lang->line('xin_success_task_added');
$Return['re_last_id'] = $row->task_id;
//get setting info
$setting = $this->Xin_model->read_setting_info(1);
if($setting[0]->enable_email_notification == 'yes') {
$this->email->set_mailtype("html");
$to_email = array();
foreach($this->input->post('assigned_to') as $p_employee) {
// assigned by
$user_info = $this->Xin_model->read_user_info($this->input->post('user_id'));
$full_name = $user_info[0]->first_name.' '.$user_info[0]->last_name;
// assigned to
$user_to = $this->Xin_model->read_user_info($p_employee);
//get company info
$cinfo = $this->Xin_model->read_company_setting_info(1);
//get email template
$template = $this->Xin_model->read_email_template(14);
$subject = $template[0]->subject.' - '.$cinfo[0]->company_name;
$logo = base_url().'uploads/logo/signin/'.$cinfo[0]->sign_in_logo;
$message = '
'.str_replace(array("{var site_name}","{var site_url}","{var task_name}","{var task_assigned_by}"),array($cinfo[0]->company_name,site_url(),$this->input->post('task_name'),$full_name),htmlspecialchars_decode(stripslashes($template[0]->message))).'
';
hrsale_mail($cinfo[0]->email,$cinfo[0]->company_name,$user_info[0]->email,$subject,$message);
}
}
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and add info in database
public function add_project() {
if($this->input->post('add_type')=='project') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$description = $this->input->post('description');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
$qt_description = $description;
$assigned_to = $this->input->post('assigned_to');
$company_id_multi = $this->input->post('company_id');
if($this->input->post('title')==='') {
$Return['error'] = $this->lang->line('xin_error_title');
} else if($this->input->post('project_no')==='') {
$Return['error'] = $this->lang->line('xin_project_projectno_field_error');
} else if($this->input->post('client_id')==='') {
$Return['error'] = $this->lang->line('xin_error_client_name');
} else if(empty($company_id_multi)) {
$Return['error'] = $this->lang->line('xin_error_company');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('budget_hours')==='') {
$Return['error'] = $this->lang->line('xin_project_budget_hrs_field_error');
} else if(empty($assigned_to)) {
$Return['error'] = $this->lang->line('xin_error_project_manager');
} else if($this->input->post('summary')==='') {
$Return['error'] = $this->lang->line('xin_error_summary');
}
if($Return['error']!=''){
$this->output($Return);
}
$assigned_ids = implode(',',$this->input->post('assigned_to'));
$employee_ids = $assigned_ids;
$company_ids = implode(',',$this->input->post('company_id'));
$c_ids = $company_ids;
$data = array(
'title' => $this->input->post('title'),
'project_no' => $this->input->post('project_no'),
'client_id' => $this->input->post('client_id'),
'company_id' => $c_ids,
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'summary' => $this->input->post('summary'),
'budget_hours' => $this->input->post('budget_hours'),
'priority' => $this->input->post('priority'),
'purchase_no' => $this->input->post('purchase_no'),
'phase_no' => $this->input->post('phase_no'),
'assigned_to' => $employee_ids,
'description' => $qt_description,
'project_progress' => '0',
'status' => '0',
'is_notify' => '1',
'added_by' => $this->input->post('user_id'),
'created_at' => date('d-m-Y'),
);
$result = $this->Project_model->add($data);
if ($result == TRUE) {
$row = $this->db->select("*")->limit(1)->order_by('project_id',"DESC")->get("xin_projects")->row();
$Return['result'] = $this->lang->line('xin_success_add_project');
$Return['re_last_id'] = $row->project_id;
// notificaions
foreach($this->input->post('assigned_to') as $p_employee){
$nticket_data = array(
'module_name' => 'projects',
'module_id' => $row->project_id,
'employee_id' => $p_employee,
'is_notify' => '1',
'created_at' => date('d-m-Y h:i:s'),
);
$this->Xin_model->add_notifications($nticket_data);
}
//get setting info
$setting = $this->Xin_model->read_setting_info(1);
if($setting[0]->enable_email_notification == 'yes') {
$this->email->set_mailtype("html");
$to_email = array();
foreach($this->input->post('assigned_to') as $p_employee) {
$user_info = $this->Xin_model->read_user_info($p_employee);
//get company info
$cinfo = $this->Xin_model->read_company_setting_info(1);
//get email template
$template = $this->Xin_model->read_email_template(3);
$subject = $template[0]->subject.' - '.$cinfo[0]->company_name;
$logo = base_url().'uploads/logo/signin/'.$cinfo[0]->sign_in_logo;
$p_date = $this->Xin_model->set_date_format($start_date);
$message = '
'.str_replace(array("{var site_name}","{var name}","{var project_name}","{var project_start_date}"),array($cinfo[0]->company_name,'User',$this->input->post('title'),$p_date),html_entity_decode(stripslashes($template[0]->message))).'
';
hrsale_mail($cinfo[0]->email,$cinfo[0]->company_name,$user_info[0]->email,$subject,$message);
}
}
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and add info in database
public function add_scrum_board_project() {
if($this->input->post('add_type')=='project') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$description = $this->input->post('description');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
$qt_description = htmlspecialchars(addslashes($description), ENT_QUOTES);
$assigned_to = $this->input->post('assigned_to');
if($this->input->post('title')==='') {
$Return['error'] = $this->lang->line('xin_error_title');
} else if($this->input->post('project_no')==='') {
$Return['error'] = $this->lang->line('xin_project_projectno_field_error');
} else if($this->input->post('client_id')==='') {
$Return['error'] = $this->lang->line('xin_error_client_name');
} else if($this->input->post('company_id')==='') {
$Return['error'] = $this->lang->line('xin_error_company');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('budget_hours')==='') {
$Return['error'] = $this->lang->line('xin_project_budget_hrs_field_error');
} else if(empty($assigned_to)) {
$Return['error'] = $this->lang->line('xin_error_project_manager');
} else if($this->input->post('summary')==='') {
$Return['error'] = $this->lang->line('xin_error_summary');
}
if($Return['error']!=''){
$this->output($Return);
}
$assigned_ids = implode(',',$this->input->post('assigned_to'));
$employee_ids = $assigned_ids;
$data = array(
'title' => $this->input->post('title'),
'project_no' => $this->input->post('project_no'),
'client_id' => $this->input->post('client_id'),
'company_id' => $this->input->post('company_id'),
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'summary' => $this->input->post('summary'),
'budget_hours' => $this->input->post('budget_hours'),
'priority' => $this->input->post('priority'),
'assigned_to' => $employee_ids,
'description' => $qt_description,
'project_progress' => '0',
'status' => $this->input->post('project_status'),
'is_notify' => '1',
'added_by' => $this->input->post('user_id'),
'created_at' => date('d-m-Y'),
);
$result = $this->Project_model->add($data);
if ($result == TRUE) {
$row = $this->db->select("*")->limit(1)->order_by('project_id',"DESC")->get("xin_projects")->row();
$Return['result'] = $this->lang->line('xin_success_add_project');
$Return['re_last_id'] = $row->project_id;
//get setting info
$setting = $this->Xin_model->read_setting_info(1);
if($setting[0]->enable_email_notification == 'yes') {
$this->email->set_mailtype("html");
$to_email = array();
foreach($this->input->post('assigned_to') as $p_employee) {
$user_info = $this->Xin_model->read_user_info($p_employee);
//get company info
$cinfo = $this->Xin_model->read_company_setting_info(1);
//get email template
$template = $this->Xin_model->read_email_template(3);
$subject = $template[0]->subject.' - '.$cinfo[0]->company_name;
$logo = base_url().'uploads/logo/signin/'.$cinfo[0]->sign_in_logo;
$p_date = $this->Xin_model->set_date_format($start_date);
$message = '
'.str_replace(array("{var site_name}","{var name}","{var project_name}","{var project_start_date}"),array($cinfo[0]->company_name,'User',$this->input->post('title'),$p_date),html_entity_decode(stripslashes($template[0]->message))).'
';
hrsale_mail($cinfo[0]->email,$cinfo[0]->company_name,$user_info[0]->email,$subject,$message);
}
}
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and update info in database
public function update() {
if($this->input->post('edit_type')=='project') {
$id = $this->uri->segment(4);
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$description = $this->input->post('description');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
$qt_description = $description;
//$qt_description = htmlspecialchars(addslashes($description), ENT_QUOTES);
$assigned_to = $this->input->post('assigned_to');
$company_id_multi = $this->input->post('company_id');
if($this->input->post('title')==='') {
$Return['error'] = $this->lang->line('xin_error_title');
} else if($this->input->post('project_no')==='') {
$Return['error'] = $this->lang->line('xin_project_projectno_field_error');
} else if($this->input->post('client_id')==='') {
$Return['error'] = $this->lang->line('xin_error_client_name');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('budget_hours')==='') {
$Return['error'] = $this->lang->line('xin_project_budget_hrs_field_error');
} else if(empty($company_id_multi)) {
$Return['error'] = $this->lang->line('xin_error_company');
} else if(empty($assigned_to)) {
$Return['error'] = $this->lang->line('xin_error_project_manager');
} else if($this->input->post('summary')==='') {
$Return['error'] = $this->lang->line('xin_error_summary');
}
if($Return['error']!=''){
$this->output($Return);
}
if(null!=$this->input->post('assigned_to')) {
$assigned_ids = implode(',',$this->input->post('assigned_to'));
$employee_ids = $assigned_ids;
} else {
$employee_ids = 'all-employees';
}
$company_ids = implode(',',$this->input->post('company_id'));
$c_ids = $company_ids;
$data = array(
'title' => $this->input->post('title'),
'project_no' => $this->input->post('project_no'),
'client_id' => $this->input->post('client_id'),
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'summary' => $this->input->post('summary'),
'priority' => $this->input->post('priority'),
'company_id' => $c_ids,
'budget_hours' => $this->input->post('budget_hours'),
'phase_no' => $this->input->post('phase_no'),
'assigned_to' => $employee_ids,
'description' => $qt_description,
'project_progress' => $this->input->post('progres_val'),
'status' => $this->input->post('status'),
);
$result = $this->Project_model->update_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_update_project');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and update info in database
public function update_status() {
if($this->input->post('type')=='update_status') {
$id = $this->input->post('project_id');
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
$data = array(
'priority' => $this->input->post('priority'),
'project_progress' => $this->input->post('progres_val'),
'status' => $this->input->post('status'),
);
$result = $this->Project_model->update_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_update_project');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and update info in database // assign_ticket
public function assign_project() {
if($this->input->post('type')=='project_user') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
if(null!=$this->input->post('assigned_to')) {
$assigned_ids = implode(',',$this->input->post('assigned_to'));
$employee_ids = $assigned_ids;
} else {
$employee_ids = '';
}
$data = array(
'assigned_to' => $employee_ids
);
$id = $this->input->post('project_id');
$result = $this->Project_model->update_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_project_employees_updated');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// update task user > task details
public function project_users() {
$data['title'] = $this->Xin_model->site_title();
$id = $this->uri->segment(3);
$data = array(
'project_id' => $id,
'all_employees' => $this->Xin_model->all_employees(),
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("project/get_project_users", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
public function discussion_list()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->Xin_model->site_title();
//$id = $this->input->get('ticket_id');
$id = $this->uri->segment(4);
$ses_user = $this->Xin_model->read_user_info($session['user_id']);
$this->load->view("admin/project/project_details", $data);
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$discussion = $this->Project_model->get_discussion($id);
$data = array();
foreach($discussion->result() as $r) {
// get user > employee_
$employee = $this->Xin_model->read_user_info($r->user_id);
// employee full name
if(!is_null($employee)){
$employee_name = $employee[0]->first_name.' '.$employee[0]->last_name;
// get designation
$_designation = $this->Designation_model->read_designation_information($employee[0]->designation_id);
if(!is_null($_designation)){
$designation_name = $_designation[0]->designation_name;
} else {
$designation_name = '--';
}
// profile picture
if($employee[0]->profile_picture!='' && $employee[0]->profile_picture!='no file') {
$u_file = base_url().'uploads/profile/'.$employee[0]->profile_picture;
} else {
if($employee[0]->gender=='Male') {
$u_file = base_url().'uploads/profile/default_male.jpg';
} else {
$u_file = base_url().'uploads/profile/default_female.jpg';
}
}
} else {
$employee_name = '--';
$designation_name = '--';
$u_file = $u_file;
}
// created at
$created_at = date('h:i A', strtotime($r->created_at));
$_date = explode(' ',$r->created_at);
$date = $this->Xin_model->set_date_format($_date[0]);
//
if($ses_user[0]->user_role_id==1){
$link = ''.$employee_name.' ('.$designation_name.')';
} else {
$link = ''.$employee_name.' ('.$designation_name.')';
}
if($r->attachment_file!='' && $r->attachment_file!='no_file'){
$at_file = ' ';
} else {
$at_file = '';
}
$function = '';
$data[] = array(
$function
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $discussion->num_rows(),
"recordsFiltered" => $discussion->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// Validate and add info in database
public function set_discussion() {
if($this->input->post('add_type')=='set_discussion') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
if($this->input->post('xin_message')==='') {
$Return['error'] = $this->lang->line('xin_project_message');
}
$xin_message = $this->input->post('xin_message');
$qt_xin_message = htmlspecialchars(addslashes($xin_message), ENT_QUOTES);
if($_FILES['attachment_discussion']['size'] == 0) {
$fname = 'no_file';
} else {
// is file upload
if(is_uploaded_file($_FILES['attachment_discussion']['tmp_name'])) {
//checking image type
$allowed = array('png','jpg','gif','jpeg','pdf','doc','docx','xls','xlsx','txt','zip','rar','gzip','ppt');
$filename = $_FILES['attachment_discussion']['name'];
$ext = pathinfo($filename, PATHINFO_EXTENSION);
if(in_array($ext,$allowed)){
$tmp_name = $_FILES["attachment_discussion"]["tmp_name"];
$attachment_file = "uploads/project/discussion/";
// basename() may prevent filesystem traversal attacks;
// further validation/sanitation of the filename may be appropriate
$name = basename($_FILES["attachment_discussion"]["name"]);
$newfilename = 'discussion_'.round(microtime(true)).'.'.$ext;
move_uploaded_file($tmp_name, $attachment_file.$newfilename);
$fname = $newfilename;
} else {
$Return['error'] = $this->lang->line('xin_error_project_file');
}
}
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'message' => $qt_xin_message,
'attachment_file' => $fname,
'project_id' => $this->input->post('discussion_project_id'),
'user_id' => $this->input->post('user_id'),
'created_at' => date('d-m-Y h:i:s')
);
$result = $this->Project_model->add_discussion($data);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_project_message_added');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
public function bug_list()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->Xin_model->site_title();
$id = $this->uri->segment(4);
$ses_user = $this->Xin_model->read_user_info($session['user_id']);
$this->load->view("admin/project/project_details", $data);
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$bug = $this->Project_model->get_bug($id);
$data = array();
foreach($bug->result() as $r) {
// get user > employee_
$employee = $this->Xin_model->read_user_info($r->user_id);
// employee full name
if(!is_null($employee)){
$employee_name = $employee[0]->first_name.' '.$employee[0]->last_name;
// get designation
$_designation = $this->Designation_model->read_designation_information($employee[0]->designation_id);
if(!is_null($_designation)){
$designation_name = $_designation[0]->designation_name;
} else {
$designation_name = '--';
}
// profile picture
if($employee[0]->profile_picture!='' && $employee[0]->profile_picture!='no file') {
$u_file = base_url().'uploads/profile/'.$employee[0]->profile_picture;
} else {
if($employee[0]->gender=='Male') {
$u_file = base_url().'uploads/profile/default_male.jpg';
} else {
$u_file = base_url().'uploads/profile/default_female.jpg';
}
}
} else {
$employee_name = '--';
$designation_name = '--';
$u_file = '--';
}
// created at
$created_at = date('h:i A', strtotime($r->created_at));
$_date = explode(' ',$r->created_at);
$date = $this->Xin_model->set_date_format($_date[0]);
//
if($ses_user[0]->user_role_id==1){
$link = ''.$employee_name.' ('.$designation_name.')';
} else {
$link = ''.$employee_name.' ('.$designation_name.')';
}
if($r->attachment_file!='' && $r->attachment_file!='no_file'){
$at_file = ' ';
} else {
$at_file = '';
}
$dlink = '';
if($r->status==0) {
$status = '';
$st_tag = ''.$this->lang->line('xin_pending').'';
} else {
$status = '';
$st_tag = ''.$this->lang->line('xin_project_status_solved').'';
}
$function = '
';
$data[] = array(
$function
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $bug->num_rows(),
"recordsFiltered" => $bug->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// Validate and add info in database
public function set_bug() {
if($this->input->post('add_type')=='set_bug') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
if($this->input->post('title')==='') {
$Return['error'] = $this->lang->line('xin_error_project_bug_title');
}
$title = $this->input->post('title');
$qt_title = htmlspecialchars(addslashes($title), ENT_QUOTES);
if($_FILES['attachment']['size'] == 0) {
$fname = 'no_file';
} else {
// is file upload
if(is_uploaded_file($_FILES['attachment']['tmp_name'])) {
//checking image type
$allowed = array('png','jpg','gif','jpeg','pdf','doc','docx','xls','xlsx','txt','zip','rar','gzip','ppt');
$filename = $_FILES['attachment']['name'];
$ext = pathinfo($filename, PATHINFO_EXTENSION);
if(in_array($ext,$allowed)){
$tmp_name = $_FILES["attachment"]["tmp_name"];
$attachment_file = "uploads/project/bug/";
// basename() may prevent filesystem traversal attacks;
// further validation/sanitation of the filename may be appropriate
$name = basename($_FILES["attachment"]["name"]);
$newfilename = 'bug_'.round(microtime(true)).'.'.$ext;
move_uploaded_file($tmp_name, $attachment_file.$newfilename);
$fname = $newfilename;
} else {
$Return['error'] = $this->lang->line('xin_error_project_file');
}
}
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'title' => $qt_title,
'attachment_file' => $fname,
'project_id' => $this->input->post('bug_project_id'),
'user_id' => $this->input->post('user_id'),
'created_at' => date('d-m-Y h:i:s')
);
$result = $this->Project_model->add_bug($data);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_project_bug_added');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and add info in database
public function add_attachment() {
if($this->input->post('add_type')=='dfile_attachment') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
if($this->input->post('file_name')==='') {
$Return['error'] = $this->lang->line('xin_error_project_file_title');
} else if($_FILES['attachment_file']['size'] == 0) {
$Return['error'] = $this->lang->line('xin_error_task_file');
} else if($this->input->post('file_description')==='') {
$Return['error'] = $this->lang->line('xin_error_task_file_description');
}
$description = $this->input->post('file_description');
$file_description = htmlspecialchars(addslashes($description), ENT_QUOTES);
if($Return['error']!=''){
$this->output($Return);
}
// is file upload
if(is_uploaded_file($_FILES['attachment_file']['tmp_name'])) {
//checking image type
$allowed = array('png','jpg','gif','jpeg','pdf','doc','docx','xls','xlsx','txt','zip','rar','gzip','ppt');
$filename = $_FILES['attachment_file']['name'];
$ext = pathinfo($filename, PATHINFO_EXTENSION);
if(in_array($ext,$allowed)){
$tmp_name = $_FILES["attachment_file"]["tmp_name"];
$attachment_file = "uploads/project/files/";
// basename() may prevent filesystem traversal attacks;
// further validation/sanitation of the filename may be appropriate
$name = basename($_FILES["attachment_file"]["name"]);
$newfilename = 'project_'.round(microtime(true)).'.'.$ext;
move_uploaded_file($tmp_name, $attachment_file.$newfilename);
$fname = $newfilename;
} else {
$Return['error'] = $this->lang->line('xin_error_project_file');
}
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'project_id' => $this->input->post('project_id'),
'upload_by' => $this->input->post('user_id'),
'file_title' => $this->input->post('file_name'),
'file_description' => $file_description,
'attachment_file' => $fname,
'created_at' => date('d-m-Y h:i:s')
);
$result = $this->Project_model->add_new_attachment($data);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_project_file_added');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// attachment list
public function attachment_list()
{
$data['title'] = $this->Xin_model->site_title();
//$id = $this->input->get('ticket_id');
$id = $this->uri->segment(4);
$session = $this->session->userdata('username');
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$attachments = $this->Project_model->get_attachments($id);
$data = array();
foreach($attachments->result() as $r) {
$data[] = array('',
$r->file_title,
$r->file_description,
$r->created_at
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $attachments->num_rows(),
"recordsFiltered" => $attachments->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// delete attachment
public function attachment_delete() {
if($this->input->post('is_ajax') == '8') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Project_model->delete_attachment_record($id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_success_project_file_deleted');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
}
// Validate and update info in database // add_note
public function add_note() {
if($this->input->post('type')=='add_note') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$data = array(
'project_note' => $this->input->post('project_note')
);
$id = $this->input->post('note_project_id');
$result = $this->Project_model->update_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_success_project_note_updated');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
public function task_categories()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$system = $this->Xin_model->read_setting_info(1);
$data['title'] = $this->lang->line('xin_task_categories').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_task_categories');
$data['path_url'] = 'task_categories';
$data['all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('45',$role_resources_ids)) {
if(!empty($session)){
$data['subview'] = $this->load->view("admin/project/task_categories", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/');
}
} else {
redirect('admin/dashboard');
}
}
public function task_categories_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/task_categories", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$task_categories = $this->Project_model->get_task_categories();
$role_resources_ids = $this->Xin_model->user_role_resource();
$data = array();
foreach($task_categories->result() as $r) {
if(in_array('346',$role_resources_ids)) { //edit
$edit = '';
} else {
$edit = '';
}
if(in_array('347',$role_resources_ids)) { // delete
$delete = '';
} else {
$delete = '';
}
$combhr = $edit.$delete;
$data[] = array(
$combhr,
$r->category_name
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $task_categories->num_rows(),
"recordsFiltered" => $task_categories->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function timelogs_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/project_timelogs_list", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$user_info = $this->Xin_model->read_user_info($session['user_id']);
if($user_info[0]->user_role_id == '1'){
$timelogs = $this->Project_model->get_all_project_timelogs();
} else {
$timelogs = $this->Project_model->get_all_project_employee_timelogs($session['user_id']);
}
$role_resources_ids = $this->Xin_model->user_role_resource();
$data = array();
foreach($timelogs->result() as $r) {
// get user > added by
$user = $this->Xin_model->read_user_info($r->employee_id);
// user full name
if(!is_null($user)){
$full_name = $user[0]->first_name.' '.$user[0]->last_name;
} else {
$full_name = '--';
}
$project = $this->Project_model->read_project_information($r->project_id);
if(!is_null($project)){
$project_name = ''.$project[0]->title.'';
} else {
$project_name = '--';
}
$start_date = $this->Xin_model->set_date_format($r->start_date);
$end_date = $this->Xin_model->set_date_format($r->end_date);
$edit = '';
$delete = '';
if($user_info[0]->user_role_id == '1'){
$combhr = $edit.$delete;
} else {
$combhr = $edit;
}
$data[] = array(
$combhr,
$project_name,
$full_name,
$start_date,
$end_date,
$r->total_hours,
$r->timelogs_memo,
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $timelogs->num_rows(),
"recordsFiltered" => $timelogs->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function project_timelogs_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/project/project_details", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$id = $this->uri->segment(4);
$timelogs = $this->Project_model->get_project_timelogs($id);
$user_info = $this->Xin_model->read_user_info($session['user_id']);
$role_resources_ids = $this->Xin_model->user_role_resource();
$data = array();
foreach($timelogs->result() as $r) {
// get user > added by
$user = $this->Xin_model->read_user_info($r->employee_id);
// user full name
if(!is_null($user)){
$full_name = $user[0]->first_name.' '.$user[0]->last_name;
} else {
$full_name = '--';
}
$start_date = $this->Xin_model->set_date_format($r->start_date);
$end_date = $this->Xin_model->set_date_format($r->end_date);
//if(in_array('346',$role_resources_ids)) { //edit
$edit = '';
//} else {
// $edit = '';
//}
//if(in_array('347',$role_resources_ids)) { // delete
$delete = '';
// } else {
// $delete = '';
// }
if($user_info[0]->user_role_id == '1'){
$combhr = $edit.$delete;
} else {
$combhr = $edit;
}
$data[] = array(
$combhr,
$full_name,
$start_date,
$end_date,
$r->total_hours,
$r->timelogs_memo,
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $timelogs->num_rows(),
"recordsFiltered" => $timelogs->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// Validate and add info in database
public function add_task_category() {
if($this->input->post('add_type')=='task_category') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
if($this->input->post('category_name')==='') {
$Return['error'] = $this->lang->line('xin_task_category_field_error');
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'category_name' => $this->input->post('category_name'),
'created_at' => date('d-m-Y h:i:s')
);
$result = $this->Project_model->add_task_categories($data);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_task_category_field_added_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and update info in database
public function task_category_update() {
if($this->input->post('edit_type')=='task_category') {
$id = $this->uri->segment(4);
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
/* Server side PHP input validation */
if($this->input->post('category_name')==='') {
$Return['error'] = $this->lang->line('xin_task_category_field_error');
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'category_name' => $this->input->post('category_name')
);
$result = $this->Project_model->update_task_category_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_task_category_field_updated_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and add info in database
public function add_project_timelog() {
if($this->input->post('add_type')=='timelog') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
/* Server side PHP input validation */
if($this->input->post('project_id')==='') {
$Return['error'] = $this->lang->line('xin_error_project_field');
} else if($this->input->post('employee_id')==='') {
$Return['error'] = $this->lang->line('xin_error_employee_id');
} else if($this->input->post('start_time')==='') {
$Return['error'] = $this->lang->line('xin_project_time_start_field_error');
} else if($this->input->post('end_time')==='') {
$Return['error'] = $this->lang->line('xin_project_time_end_field_error');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('timelogs_memo')==='') {
$Return['error'] = $this->lang->line('xin_project_memo_field_error');
}
if($Return['error']!=''){
$this->output($Return);
}
$project = $this->Project_model->read_project_information($this->input->post('project_id'));
if(!is_null($project)){
$cid = $project[0]->company_id;
} else {
$cid = 0;
}
$data = array(
'project_id' => $this->input->post('project_id'),
'company_id' => $cid,
'employee_id' => $this->input->post('employee_id'),
'start_time' => $this->input->post('start_time'),
'end_time' => $this->input->post('end_time'),
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'total_hours' => $this->input->post('total_hours'),
'timelogs_memo' => $this->input->post('timelogs_memo'),
'created_at' => date('Y-m-d h:i:s')
);
$result = $this->Project_model->add_project_timelog($data);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_project_timelogs_added_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
// Validate and update info in database
public function update_project_timelog() {
if($this->input->post('edit_type')=='timelog_record') {
$id = $this->uri->segment(4);
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$st_date = strtotime($start_date);
$ed_date = strtotime($end_date);
/* Server side PHP input validation */
if($this->input->post('start_time')==='') {
$Return['error'] = $this->lang->line('xin_project_time_start_field_error');
} else if($this->input->post('end_time')==='') {
$Return['error'] = $this->lang->line('xin_project_time_end_field_error');
} else if($this->input->post('start_date')==='') {
$Return['error'] = $this->lang->line('xin_error_start_date');
} else if($this->input->post('end_date')==='') {
$Return['error'] = $this->lang->line('xin_error_end_date');
} else if($st_date > $ed_date) {
$Return['error'] = $this->lang->line('xin_error_start_end_date');
} else if($this->input->post('timelogs_memo')==='') {
$Return['error'] = $this->lang->line('xin_project_memo_field_error');
}
if($Return['error']!=''){
$this->output($Return);
}
$data = array(
'start_time' => $this->input->post('start_time'),
'end_time' => $this->input->post('end_time'),
'start_date' => $this->input->post('start_date'),
'end_date' => $this->input->post('end_date'),
'total_hours' => $this->input->post('total_hours'),
'timelogs_memo' => $this->input->post('timelogs_memo')
);
$result = $this->Project_model->update_project_timelog_record($data,$id);
if ($result == TRUE) {
$Return['result'] = $this->lang->line('xin_project_timelogs_updated_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
exit;
}
}
public function read_timelog_record()
{
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('timelogs_id');
$result = $this->Project_model->read_timelog_info($id);
$data = array(
'timelogs_id' => $result[0]->timelogs_id,
'project_id' => $result[0]->project_id,
'company_id' => $result[0]->company_id,
'employee_id' => $result[0]->employee_id,
'start_time' => $result[0]->start_time,
'end_time' => $result[0]->end_time,
'start_date' => $result[0]->start_date,
'end_date' => $result[0]->end_date,
'total_hours' => $result[0]->total_hours,
'timelogs_memo' => $result[0]->timelogs_memo,
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_project_timelogs', $data);
} else {
redirect('admin/');
}
}
public function read_project_timelog_record()
{
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('timelogs_id');
$result = $this->Project_model->read_timelog_info($id);
$data = array(
'timelogs_id' => $result[0]->timelogs_id,
'project_id' => $result[0]->project_id,
'company_id' => $result[0]->company_id,
'employee_id' => $result[0]->employee_id,
'start_time' => $result[0]->start_time,
'end_time' => $result[0]->end_time,
'start_date' => $result[0]->start_date,
'end_date' => $result[0]->end_date,
'total_hours' => $result[0]->total_hours,
'timelogs_memo' => $result[0]->timelogs_memo,
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_project_timelogs_record', $data);
} else {
redirect('admin/');
}
}
public function task_category_read()
{
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('task_category_id');
$result = $this->Project_model->read_task_category_information($id);
$data = array(
'task_category_id' => $result[0]->task_category_id,
'category_name' => $result[0]->category_name
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/project/dialog_task_categories', $data);
} else {
redirect('admin/');
}
}
public function delete_task_category() {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Project_model->delete_task_category_record($id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_task_category_field_deleted_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
public function bug_read()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('bug_id');
$result = $this->Project_model->read_bug_information($id);
$data = array(
'bug_id' => $result[0]->bug_id,
'project_id' => $result[0]->project_id,
'status' => $result[0]->status,
);
$this->load->view('admin/project/dialog_project_bug', $data);
}
public function change_bug_status() {
if($this->input->post('data') == 'change_status') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$data = array(
'status' => $this->input->post('status'),
);
$result = $this->Project_model->update_bug($data,$id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_success_project_bug_status_updated');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
}
public function bug_delete() {
if($this->input->post('data') == 'bug') {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Project_model->delete_bug_record($id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_success_project_bug_deleted');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
}
public function delete() {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Project_model->delete_record($id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_success_delete_project');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
public function delete_timelog() {
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Project_model->delete_timelog_record($id);
if(isset($id)) {
$Return['result'] = $this->lang->line('xin_project_timelogs_deleted_success');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
}