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("Clients_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('client_username');
if(empty($session)){
redirect('client/auth/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('client/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_client';
$data['subview'] = $this->load->view("client/project/project_list", $data, TRUE);
$this->load->view('client/layout/layout_main', $data); //page load
}
public function detail()
{
$session = $this->session->userdata('client_username');
if(empty($session)){
redirect('client/auth/');
}
$system = $this->Xin_model->read_setting_info(1);
if($system[0]->module_projects_tasks!='true'){
redirect('client/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['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('client/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,
'status' => $result[0]->status,
'path_url' => 'project_detail_client',
'all_clients' => $this->Clients_model->get_all_clients(),
'all_employees' => $this->Xin_model->all_employees(),
'all_companies' => $this->Xin_model->get_companies()
);
$data['subview'] = $this->load->view("client/project/project_details", $data, TRUE);
$this->load->view('client/layout/layout_main', $data); //page load
}
public function project_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('client_username');
if(!empty($session)){
$this->load->view("client/project/project_list", $data);
} else {
redirect('client/auth/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$project = $this->Project_model->get_client_projects($session['client_id']);
$data = array();
foreach($project->result() as $r) {
// 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
$pdate = ' '.$this->Xin_model->set_date_format($r->end_date);
//project_progress
if($r->project_progress <= 20) {
$progress_class = 'progress-danger';
} else if($r->project_progress > 20 && $r->project_progress <= 50){
$progress_class = 'progress-warning';
} else if($r->project_progress > 50 && $r->project_progress <= 75){
$progress_class = 'progress-info';
} else {
$progress_class = 'progress-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 {
$status = $this->lang->line('xin_deffered');
}
// 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 .= '';
}
$project_summary = '
'.$r->summary.'
';
$data[] = array(
$project_summary,
$priority,
$pdate,
$pbar,
$ol
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $project->num_rows(),
"recordsFiltered" => $project->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// project task list > timesheet
public function project_task_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('client_username');
// 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);
$task = $this->Timesheet_model->get_project_tasks($id);
$data = array();
foreach($task->result() as $r) {
if($r->assigned_to == '' || $r->assigned_to == 'None') {
$ol = $this->lang->line('xin_performance_none');
} else {
$ol = '';
foreach(explode(',',$r->assigned_to) as $uid) {
$assigned_to = $this->Xin_model->read_user_info($uid);
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 .= '';
} 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 .= '';
}
//
}
}
$ol .= '';
}
//$ol = 'A';
/* get User info*/
$u_created = $this->Xin_model->read_user_info($r->created_by);
$f_name = $u_created[0]->first_name.' '.$u_created[0]->last_name;
/// set task progress
if($r->task_progress=='' || $r->task_progress==0): $progress = 0; else: $progress = $r->task_progress; endif;
// task progress
if($r->task_progress <= 20) {
$progress_class = 'progress-danger';
} else if($r->task_progress > 20 && $r->task_progress <= 50){
$progress_class = 'progress-warning';
} else if($r->task_progress > 50 && $r->task_progress <= 75){
$progress_class = 'progress-info';
} else {
$progress_class = 'progress-success';
}
$progress_bar = ''.$this->lang->line('xin_completed').' '.$r->task_progress.'%
';
// task status
if($r->task_status == 0) {
$status = $this->lang->line('xin_not_started');
} else if($r->task_status ==1){
$status = $this->lang->line('xin_in_progress');
} else if($r->task_status ==2){
$status = $this->lang->line('xin_completed');
} else {
$status = $this->lang->line('xin_deffered');
}
// task end date
$tdate = $this->Xin_model->set_date_format($r->end_date);
$data[] = array(
'',
$r->task_name,
$tdate,
$status,
$ol,
$f_name,
$progress_bar
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $task->num_rows(),
"recordsFiltered" => $task->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,
'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('client/project/dialog_project', $data);
} else {
redirect('client/auth/');
}
}
// 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();
}
}